Mastering Microsoft Excel Power Query Editor
This course is designed to equip participants with the skills needed to effectively use the Power Query Editor in Microsoft Excel. Throughout the course, participants will learn to navigate the Power Query Editor interface, transform and clean data, and apply best practices in data preparation for analysis. The course includes hands-on modules covering topics such as importing data from multiple Excel Worksheets, Excel Workbooks and other various sources, using data transformation tools, and performing advanced data transformations like pivot tables and charts.
By the end of the course, participants will have a solid understanding of the tools available in the Power Query Editor and be able to confidently prepare data for analysis by using Pivot Tables, Charts and Power Pivot.
4 courses found
-
- Delivery Format: Virtual Learning
- Date 14 January, 2026 | 9:30 AM to 4:30 PM
- Location: Virtual (GMT Standa)
- Language: English
-
- Delivery Format: Virtual Learning
- Date 18 March, 2026 | 9:30 AM to 4:30 PM
- Location: Virtual (GMT Standa)
- Language: English
-
- Delivery Format: Virtual Learning
- Date 16 June, 2026 | 9:30 AM to 4:30 PM
- Location: Virtual (GMT Standa)
- Language: English
-
- Delivery Format: Virtual Learning
- Date 07 September, 2026 | 9:30 AM to 4:30 PM
- Location: Virtual (GMT Standa)
- Language: English
Request a date or location for this course